let server = require("express")();
let mysql = require("mysql")
let port = 8080;
let sql = mysql.createConnection({
	host     : 'localhost',
	user     : 'root',
	password : '123456',
	database : 'chuanyue',
	timezone:"08:00",
	port:3306
})
sql.connect();

server.all("*",function(req,res,next){
    //设置允许跨域的域名，*代表允许任意域名跨域
    res.header("Access-Control-Allow-Origin","*");
    //允许的header类型
    res.header("Access-Control-Allow-Headers","content-type");
    //跨域允许的请求方式 
    res.header("Access-Control-Allow-Methods","DELETE,PUT,POST,GET,OPTIONS");
    if (req.method.toLowerCase() == 'options')
        res.send(200);  //让options尝试请求快速结束
    else
        next();
})


server.get("/getanliList",(request,response)=>{
	sql.query(`SELECT id,title,tag,faceImg FROM anli`,(error,data)=>{
		if(error){
			console.log(error)
			response.end("error")
			return
		}
		response.end(JSON.stringify(data))
	})
})


server.get("/getDetails",(request,response)=>{
	let id = request.query.id;
	sql.query(`SELECT * FROM anli WHERE id=${id}`,(error,data)=>{
		if(error){
			console.log(error)
			response.end("error")
			return
		}
		else{
			response.end(JSON.stringify(data[0]))
		}
	})
})

server.listen(port)
console.log(`server is running at ${port}`)